Domain: Consumer Goods | Function: Executive Management
Atliq Hardwares (imaginary company) is one of the leading computer hardware producers in India and well expanded in other countries too.
However, the management noticed that they do not get enough insights to make quick and smart data-informed decisions. They want to expand their data analytics team by adding several junior data analysts. Tony Sharma, their data analytics director wanted to hire someone who is good at both tech and soft skills. Hence, he decided to conduct a SQL challenge which will help him understand both the skills.
Task:
Imagine yourself as the applicant for this role and perform the following task
1. Check ‘ad-hoc-requests.pdf’ - there are 10 ad hoc requests for which the business needs insights.
2. You need to run a SQL query to answer these requests.
3. The target audience of this dashboard is top-level management - hence you need to create a presentation to show the insights.
4. Be creative with your presentation, audio/video presentation will have more weightage.
Other resources Provided:
a. Dataset required to provide
b. Metadata
c. Hints (try not to use the hints to develop your skills quicker)
d. Sample questions and Presentation
Domain: Hospitality Function: Revenue
AtliQ Grands owns multiple five-star hotels across India. They have been in the hospitality industry for the past 20 years. Due to strategic moves from other competitors and ineffective decision-making in management, AtliQ Grands are losing its market share and revenue in the luxury/business hotels category. As a strategic move, the managing director of AtliQ Grands wanted to incorporate “Business and Data Intelligence” to regain their market share and revenue. However, they do not have an in-house data analytics team to provide them with these insights.
Their revenue management team had decided to hire a 3rd party service provider to provide them with insights from their historical data.
Task:
You are a data analyst who has been provided with sample data and a mock-up dashboard to work on the following task. You can download all relevant documents from the download section.
Problem Statement
AtliQ Mart is a growing FMCG manufacturer headquartered in Gujarat, India. It is currently operational in three cities Surat, Ahmedabad and Vadodara. They want to expand to other metros/Tier 1 cities in the next 2 years.
AtliQ Mart is currently facing a problem where a few key customers did not extend their annual contracts due to service issues. It is speculated that some of the essential products were either not delivered on time or not delivered in full over a continued period, which could have resulted in bad customer service. Management wants to fix this issue before expanding to other cities and requested their supply chain analytics team to track the ’On time’ and ‘In Full’ delivery service level for all the customers daily basis so that they can respond swiftly to these issues.
The Supply Chain team decided to use a standard approach to measure the service level in which they will measure ‘On-time delivery (OT) %’, ‘In-full delivery (IF) %’, and OnTime in full (OTIF) %’ of the customer orders daily basis against the target service level set for each customer.
Task:
Peter Pandey is the data analyst in the supply chain team who joined AtliQ Mart recently. He has been briefed about the the task in the stakeholder business review meeting. Now imagine yourself as Peter Pandey and play the role of the new data analyst who is excited to build this dashboard and perform the following task:
Other resources Provided:
Domain: Telecom Function: Executive Management
AtliQo is one of the leading telecom providers in India and launched its 5G plans in May 2022 along with other telecom providers.
However, the management noticed a decline in their active users and revenue growth post 5G launch in May 2022. AtliQo’s business director requested their analytics team to provide a comparison report of KPIs between pre and post-periods of the 5G launch. The management is keen to compare the performance between these periods and get insights that would enable them to make informed decisions to recover their active user rate and other key metrics. They also wonder if they can optimize their internet plans to get more active users. Peter Pandey, a junior data analyst, is assigned to this task.
Task:
Imagine yourself as Peter Pandey and perform the following task:
Other resources Provided:
A real-time data analytics project to add to your resume.
An opportunity to learn data analytics using business use cases and datasets.
The top 3 submissions will get an attractive prize.
Every qualified submission gets an appreciation certificate.
30% scholarship on our premium courses for all qualified submissions.
Reach out to the Codebasics team at the
Discord Channel
Its actually going nice. The way you are explaining each topic in depth and showing the right path to do the things is really helpful to know about the real world practices.
I would first of all like thanks both dhaval sir and hemanand sir for their sincere efforts for creating this course and that too at such a low price. Second i would say if you are a beginner and you don't know about power bi and business you must go with this course because it is a complete package ,it starts with a business problem and it also tells us about how a person asks questions to his stakeholders before starting to solve the actual problem. Not only that but asking clear and crisp questions that what is their actual requirement. I would say that this course is a complete power pack for a data and business enthusiast.
I learn so many Business related things like Business Terms, How to Calculate Profit by counting on so many parameters which gives me an understanding that how profit earns. Another thing is you get to learn so many tools optimizing things that make Power BI workflow faster.
I highly recommended this course for those who want to become a data analyst, This is the one and only best course I have seen in data analytics using power bi
This Course is one of the best Power BI Course in the market. Here you not only learned about the tool(PowerBI) but also business terms like P & L and Supply Chain Management etc.
Definitely the best course for PowerBI with hands on projects. Learnt a lot Thanks for making this course.
It's one of the best courses ever for data analytics enthusiasts, and those who all want to change their career transition from non-tech to tech I highly recommend this course, the way Dhaval Patel sir and Hemanand Vadivel sir explanation is really awesome. Moreover, thanks to Nick Puri and those stakeholders for showing me how this work is carried out in the organization.
This was a comprehensive course on PowerBI. It not only teaches PowerBI as a tool but also how data analysis tasks are carried out in an organization. It gives an insight on how it would be to join an organization as a junior data analyst/ data analyst and what approach should one take when working with data (asking the right questions, giving inputs etc.). Thank you codebasics.
I watched Data science Tutorial video on Youtube. so I was amazed at how Dhaval patel explained each concept in an effortless manner. So when this course launched I bought the course without any hesitation, and This course completed all my expectations. This course truly gives me the best ROI in my career.
This is my first Power BI course, earlier I learnt basics from codebasics sales insights YouTube video series. This is the perfect course for anyone who wants to enter into data analytics field. All the concepts of Power BI and business domain are explained in depth with practical implementation. And course is designed as if you are working on real world project as a data analyst in organization.
This is a highly recommended course from my end for all those who are willing to transition into data analytics domain. It has project ,It also covered the business understanding and ethics . Just by observing at the instructor you will learn a lot about presentation skills . Overall a fully power packed course ( Don't want to disclose more about course just do it )
course worth 20k rupees..best course so far
This is by far the "COMPLETE" package required for a Power BI project. From bottom of my heart, I really Thank the Codebasics team for creating this course. My takeaway from this course is "Confidence". That's it.
Thanks for the course, it was super useful in my data analyst path. As Dhaval sir mentioned, even a high school student can understand the concepts clearly.
Hey, Anyone who is reading this review while thinking whether he/she should it or not. Just dont think and go for it. It is worth your every penny and every sec that you will be spending. Course is superb and in very in depth. Thank you Dhaval for this.
Really I was lucky to learn this course . As thing which look tough in some online course But Dhaval sir with his witty humour and friendly approach made it easier to learn without knowing that it was finished . Only thing left is to put this into practice in real world and learn even more . Thank you Dhaval Sir , Hemanand sir also our Nick Puri for showing how its work in real world .
The learning was made in a really fun and engaging manner. Cannot ask for anything better!!
Excellent presentation by you Sir.I am privileged to learned this course by you to learn real time project which make me got to know more about actual exploration of data analysis. THANK YOU
Thanks a lot CodebasIcs team for your valuable Time & Effort.., Guys how are searching for an Power BI Course can take this without hesitation, Im sure it will help you a lot on not only in this BI tool also we can gain Real time experience. Give It a shot Worth compared to other Courses in market.
This course is the full package! it teaches and exemplifies the job of a data analyst in a working environment. The lessons are easy to understand and follow, and the assignments are tasking and challenging.
It was a fantastic experience doing this course. Learned so much more about Data Analytics than in any other course available on the internet.
This course was very detailed and clear. Thanks a lot for all your efforts in making such a wonderful course.
This course is my first step towards carrier transition from mechanical engineering to Data Analytics .Here i Learn a lot new tool and technologies how they can work ,it is a best course and best platform to get a feel of how a fresher real data analyst initialize his work in a organization,Thank you Dhavel Sir, Thanks Codebasics.....!!!
Absolutely the best Project available on Internet, what make this project special is, you learn everything in detail about data analytics. All i can say is Thankyou
It's a premium course taught by the experts in the Data Industry ! Have taken so many different courses from various platform for BI tools, this course is absolutely opposite and to the next level ! Thank you Dhaval Patel sir and codebasics team for launching such a amazing course !
Best learning platform compared to other ones. A perfect skill stack to boost your knowledge as well as the career. Thank You Code Basics Team
No data analytics course is as good as this course , I personally feel that This course has so much potential to change a person and build so much confidence in him that he can face any challenge in the industry very easily and I am enjoying this part of learning
WOW, This was a Wonderful course for beginners who start their carrier in data analytics , as well as for the experienced person from different domain. I am telling this because, I am from a different domain. It was blended with Technical stuffs & Project Management skills. Thank you Dhaval Patel sir & Hemanand Vadivel sir for making this fruitful course.
Great Course! The course is very insightful and professional. The chapter were clear and informative. Thank You so much...nice experience...
Excellent. Best most efficient way to go from beginner to advanced. I would love to see another course that does a deeper dive into doing the same thing, but with more M, all the external tools (tabulator editor 3, dax, data dictionary automation, etc), dna enterprise master date table with offset, I have every reason to believe this group could pull it off. Take BI user from advanced to expert.
The course have make me to have a direction in the new career that I choose, that I can do it with determination, although this is my first time of going through the course of which I plan to go through it like twice, to enable me create different Reports on my own. There so many tools to learn actually which will come with a lot of practices, I can not wait to become a master in this field. Thank
Great learning experience with real time project example, its take lot of time to me for completing the course since its not about only using tool, instead I learn to use this tool for generating useful insight from data with respective business problem.
A perfect course for data analysis in which you get real world case scenarios to study and get hands-on, to get job ready in data analytics world. Thank you Dhaval Patel for a wonderful experience!!
I am from commerce background, still this course helps me in learning power bi well thnks sir 🙏🙏 for making such an amazing platform for learning power bi in a simple way.
This course really helped me to get rid of the naivety I had in my mind about how exactly a data analytics project would look like in a real business setting, and it really helped in my learning process. Also, Dhaval sir's teaching style is very unique and I think that helped me a lot in reducing the time I took to understand each concepts.
I loved this course. I learned a lot from this course and enjoyed the way you taught us every lesson. Wish you all the best and thanks for starting such an amazing course. I will also be with Codebasics in my learning of new technology.
Exceptionally designed course which has power to turn any non tech fellow to kick start in the world of DATA. Course takes you through the almost all aspects and all stages of data analysis process performed by the seasoned data professionals in the real time scenario.
By far one of the best course related to Data Analysis I have come across. Rather than just learning what the tool does and the functions in it, you gain an overall perspective on approaching and utilizing Power BI from a project point of view. It is a brilliant course! I recommend this course to anyone in the field of analytics or ones who are looking to start afresh or switch their career.
Thank you Sir for such a wonderful course, very nicely explained, and seriously it is like working on real project, got some real project exposure. Please make course on other technologies also in Future.
Absolutely awesome. The way that this course teaches and the value of the information that it gives is something that you don't find anywhere else. In love with Peter Pandey
As promised, this course is 5X of YT playlist. It took me around 3 weeks to complete this course with my full-time job, as always I loved the course and learnt a lot. Mainly the mimicking of real time project scenarios with meeting sessions is so real and can give true exposure to working in corporate. The course is abundant on tips and knowledge of data analytics. I strongly recommend it.
This is my first online course. The project-based learning method is really easy to understand. This course covers end to end business processes and helped me to gain good knowledge of business domain and some soft skills. Thanks to Dhaval and Hemanand for this awesome course. I am confident that, after finishing the course I can work on my own to solve more complex problems.
I completed this course a few days ago and trust me it is one of the best courses because it teaches you about Power BI through a project (practically) rather than focusing only on theory. Now I have joined several Power BI groups on LinkedIn & Telegram and I was even able to answer the queries & it felt really amazing to contribute back to the community. I'll definitely recommend this course :)
As a beginner Power BI learner with over 100 practice hours previously, after completing the course I must say this course definitely gets you job ready skills.
Was a great kickstart to my goal of data analytics in Power BI. Totally worth the money
Amazing work, great description and loved the way things are explained in such a simple and effective manner. Looking forward for more such technical courses to learn.
It's a wonderful course that helped me learn Power BI by creating a project. It is one of the best courses I have attended so far. This course starts up with a problem statement and drives you through real project-like scenarios and also provides you with a few soft skills that will help you grow in your career. Overall it was an amazing experience. Thanks a lot, Dhaval and Hemanand sir.
Thank you very much for this course @codebasics & @Hem! You did a great job creating this course! Congrats!
After 10 years of working in a different field when I wanted to make a career transformation, I stumbled upon "Code Basics" YouTube channel and from there to this course. I am still grateful for the day I did. I am 85% through the course and pretty much confident I can transition into a Data Analyst's role easily. Wish I could Thank you Personally
The course is really insightful as the course structure is designed in such a manner that a beginner in this Data Analytics domain gets to work in a guided real industry relevant project . The project has really ignited my interest to learn and practice from similar projects in order to gain meaningful insights by doing similar in depth Analysis in Power BI.
Completed 40% of the Course. To be Frank, this course makes me feel like I am working in the Real Time working conditions. The uniqueness about the course is how to build the soft skills which is very crucial while learning the technical skills. Never felt bored or heavy and each tutorial feels like watching a favorite movie...My Big Thanks for Dhaval and Hemanand Sir for this amazing concept.
I would definitely recommend this course to anyone who is looking forward to starting a career in Data Analytics. It covers all the required topics from the basics to state of the art. The teaching style of Dhaval Patel is amazing. Kudos to Hemanand Vadivel
The quality of the course is outstanding in every aspect and your way of teaching (No words to describe it, you are the best at what you do). No second thought about it. The video quality, that too in 4k is just a Visual Wonder for me. You and 'Hemanand Vadivel' Sir have created awesome content.
Almost 40% through my course, and I must say the course is very detailed and pragmatic! I like it how you motivate at the beginning of each new section in the chapter. It's like you're reading my mind + absolutely love how I can update my review like a reflection journal.
I just completed 50% of the course, I am feeling like I am working as a data analyst in a startup company. it is very practical actually. I 100% recommend this course. it helps me a lot. thanks, code basic team for designing such nice content at an affordable price.
I bought Both courses and they are more than 7 stars!!! Your courses are very great!! I really appreciate it.
Thank you so much for the valuable content. The way of your teaching was very impressive and it makes me understand the concept very easily. And also I have watched your powerbi, python, data structure youtube playlist, those are the best videos I have ever seen. It all helps me to get prepared for the interview.
Watched your YouTube videos got inspired to switch to data analytics and after completing this course can proudly say that now i know data analysis and PowerBi in detail... Dhaval sir ty😊
This is one of the best courses that are available on the internet. The project-based learning that takes you through the problem statement and possible solutions which makes it amazing. It is worth every penny and hats off to the team for making it more affordable.
The course has helped build confidence in my data analytics career. I have managed to learn not only the technical aspects but also the soft skills plus Dhaval Patel has got a lot of humor which makes the course more interesting and engaging.
I highly recommend this course. Sir Dhaval and he's team did a great job in preparing this course. The way industry terminology are presented in a comic pattern helps even a newbie to understand financial analytics in business, domain knowledge and effective communication to stakeholders through engaging story telling via visualization.
This course come with full package of knowledge which is very necessary for every data analyst to learn. In this course every basic detail and wide concept are provided in such a way that anyone can learn easily even a nontechnical background.
This course was really interactive. I had learnt Excel and MySQL individually at some point but couldn't fathom the connections among this data analytics tool. But this course connected the dots for me and the role plays made it a realistic one. I am confident to continue my pursuit for Sales operations or Supply chain analyst role.
